Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 254312 |
| Missing cells | 25310 |
| Missing cells (%) | 0.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 27.2 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 11 |
|---|---|
| DateTime | 1 |
| Categorical | 1 |
MP1 FLOW1 (l/s) is highly correlated with MP1 PDEPTH_1 (mm) and 3 other fields | High correlation |
MP1 PDEPTH_1 (mm) is highly correlated with MP1 FLOW1 (l/s) and 3 other fields | High correlation |
MP1 UNIDEPTH (mm) is highly correlated with MP1 FLOW1 (l/s) and 3 other fields | High correlation |
MP1 UpDEPTH_1 (mm) is highly correlated with MP1 FLOW1 (l/s) and 3 other fields | High correlation |
MP1 WATERTEMP_1 (°C) is highly correlated with month | High correlation |
Raw Average Velocity (m/s) is highly correlated with MP1 FLOW1 (l/s) and 3 other fields | High correlation |
month is highly correlated with MP1 WATERTEMP_1 (°C) | High correlation |
MP1 FLOW1 (l/s) is highly correlated with MP1 PDEPTH_1 (mm) and 3 other fields | High correlation |
MP1 PDEPTH_1 (mm) is highly correlated with MP1 FLOW1 (l/s) and 2 other fields | High correlation |
MP1 UNIDEPTH (mm) is highly correlated with MP1 FLOW1 (l/s) and 2 other fields | High correlation |
MP1 UpDEPTH_1 (mm) is highly correlated with MP1 FLOW1 (l/s) and 2 other fields | High correlation |
MP1 WATERTEMP_1 (°C) is highly correlated with month | High correlation |
Raw Average Velocity (m/s) is highly correlated with MP1 FLOW1 (l/s) | High correlation |
month is highly correlated with MP1 WATERTEMP_1 (°C) | High correlation |
MP1 FLOW1 (l/s) is highly correlated with MP1 PDEPTH_1 (mm) and 3 other fields | High correlation |
MP1 PDEPTH_1 (mm) is highly correlated with MP1 FLOW1 (l/s) and 2 other fields | High correlation |
MP1 UNIDEPTH (mm) is highly correlated with MP1 FLOW1 (l/s) and 2 other fields | High correlation |
MP1 UpDEPTH_1 (mm) is highly correlated with MP1 FLOW1 (l/s) and 2 other fields | High correlation |
Raw Average Velocity (m/s) is highly correlated with MP1 FLOW1 (l/s) | High correlation |
Daily Cumulative Rainfall (mm) is highly correlated with MP1 FLOW1 (l/s) and 3 other fields | High correlation |
MP1 FLOW1 (l/s) is highly correlated with Daily Cumulative Rainfall (mm) and 4 other fields | High correlation |
MP1 PDEPTH_1 (mm) is highly correlated with Daily Cumulative Rainfall (mm) and 3 other fields | High correlation |
MP1 UNIDEPTH (mm) is highly correlated with Daily Cumulative Rainfall (mm) and 3 other fields | High correlation |
MP1 UpDEPTH_1 (mm) is highly correlated with Daily Cumulative Rainfall (mm) and 3 other fields | High correlation |
MP1 WATERTEMP_1 (°C) is highly correlated with month | High correlation |
Raw Average Velocity (m/s) is highly correlated with MP1 FLOW1 (l/s) and 1 other fields | High correlation |
month is highly correlated with MP1 WATERTEMP_1 (°C) | High correlation |
targets is highly correlated with Raw Average Velocity (m/s) | High correlation |
MP1 FLOW1 (l/s) has 4213 (1.7%) missing values | Missing |
MP1 PDEPTH_1 (mm) has 4213 (1.7%) missing values | Missing |
MP1 UNIDEPTH (mm) has 4213 (1.7%) missing values | Missing |
MP1 UpDEPTH_1 (mm) has 4213 (1.7%) missing values | Missing |
MP1 WATERTEMP_1 (°C) has 4213 (1.7%) missing values | Missing |
Raw Average Velocity (m/s) has 4213 (1.7%) missing values | Missing |
Final Rainfall (mm) is highly skewed (γ1 = 42.53877637) | Skewed |
MP1 PDEPTH_1 (mm) is highly skewed (γ1 = 38.566953) | Skewed |
MP1 UNIDEPTH (mm) is highly skewed (γ1 = 39.01797907) | Skewed |
date has unique values | Unique |
Daily Cumulative Rainfall (mm) has 176634 (69.5%) zeros | Zeros |
Final Rainfall (mm) has 246640 (97.0%) zeros | Zeros |
MP1 FLOW1 (l/s) has 4243 (1.7%) zeros | Zeros |
Raw Average Velocity (m/s) has 4243 (1.7%) zeros | Zeros |
hour has 10597 (4.2%) zeros | Zeros |
Reproduction
| Analysis started | 2021-12-13 10:15:18.559260 |
|---|---|
| Analysis finished | 2021-12-13 10:15:42.133796 |
| Duration | 23.57 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 447 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 16 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.064516157 |
| Minimum | 0 |
|---|---|
| Maximum | 68.5 |
| Zeros | 176634 |
| Zeros (%) | 69.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.2 |
| 95-th percentile | 6.6 |
| Maximum | 68.5 |
| Range | 68.5 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 3.505419053 |
|---|---|
| Coefficient of variation (CV) | 3.292969328 |
| Kurtosis | 65.65429192 |
| Mean | 1.064516157 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.553403856 |
| Sum | 270702.2005 |
| Variance | 12.28796273 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 176634 | |
| 0.2 | 11024 | 4.3% |
| 0.1 | 5860 | 2.3% |
| 0.4 | 4825 | 1.9% |
| 0.3 | 3901 | 1.5% |
| 0.6 | 3176 | 1.2% |
| 0.5 | 2792 | 1.1% |
| 1.6 | 1939 | 0.8% |
| 1.2 | 1710 | 0.7% |
| 0.8 | 1640 | 0.6% |
| Other values (437) | 40795 | 16.0% |
| Value | Count | Frequency (%) |
| 0 | 176634 | |
| 0.1 | 5860 | 2.3% |
| 0.2 | 11024 | 4.3% |
| 0.3 | 3901 | 1.5% |
| 0.4 | 4825 | 1.9% |
| 0.5 | 2792 | 1.1% |
| 0.6 | 3176 | 1.2% |
| 0.7 | 846 | 0.3% |
| 0.8 | 1640 | 0.6% |
| 0.9 | 755 | 0.3% |
| Value | Count | Frequency (%) |
| 68.5 | 1 | |
| 68.3 | 1 | |
| 68.1 | 1 | |
| 67.9 | 1 | |
| 67.8 | 1 | |
| 67.6 | 1 | |
| 67.4 | 1 | |
| 67.3 | 1 | |
| 67.2 | 1 | |
| 67.1 | 1 |
| Distinct | 48 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.007212461069 |
| Minimum | 0 |
|---|---|
| Maximum | 9.4 |
| Zeros | 246640 |
| Zeros (%) | 97.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 9.4 |
| Range | 9.4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.08117148965 |
|---|---|
| Coefficient of variation (CV) | 11.25434008 |
| Kurtosis | 2825.097805 |
| Mean | 0.007212461069 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 42.53877637 |
| Sum | 1834.1 |
| Variance | 0.006588810732 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 246640 | |
| 0.1 | 3560 | 1.4% |
| 0.2 | 2684 | 1.1% |
| 0.4 | 588 | 0.2% |
| 0.3 | 318 | 0.1% |
| 0.6 | 166 | 0.1% |
| 0.5 | 62 | < 0.1% |
| 0.8 | 61 | < 0.1% |
| 1 | 42 | < 0.1% |
| 1.2 | 24 | < 0.1% |
| Other values (38) | 151 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 246640 | |
| 0.1 | 3560 | 1.4% |
| 0.2 | 2684 | 1.1% |
| 0.3 | 318 | 0.1% |
| 0.4 | 588 | 0.2% |
| 0.5 | 62 | < 0.1% |
| 0.6 | 166 | 0.1% |
| 0.7 | 18 | < 0.1% |
| 0.8 | 61 | < 0.1% |
| 0.9 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.4 | 1 | < 0.1% |
| 7.2 | 2 | |
| 7.1 | 1 | < 0.1% |
| 6.2 | 1 | < 0.1% |
| 5.8 | 1 | < 0.1% |
| 5.6 | 2 | |
| 5.4 | 1 | < 0.1% |
| 5.2 | 1 | < 0.1% |
| 5 | 2 | |
| 4.8 | 4 |
MP1 FLOW1 (l/s)
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 241368 |
|---|---|
| Distinct (%) | 96.5% |
| Missing | 4213 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.006886341 |
| Minimum | 0 |
|---|---|
| Maximum | 66.66148 |
| Zeros | 4243 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.5910277 |
| Q1 | 3.30221 |
| median | 4.912778 |
| Q3 | 6.24276 |
| 95-th percentile | 8.8093148 |
| Maximum | 66.66148 |
| Range | 66.66148 |
| Interquartile range (IQR) | 2.94055 |
Descriptive statistics
| Standard deviation | 2.776194198 |
|---|---|
| Coefficient of variation (CV) | 0.5544751786 |
| Kurtosis | 64.78056525 |
| Mean | 5.006886341 |
| Median Absolute Deviation (MAD) | 1.456098 |
| Skewness | 4.536605925 |
| Sum | 1252217.267 |
| Variance | 7.707254225 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4243 | 1.7% |
| 5.285726 | 4 | < 0.1% |
| 4.271876 | 3 | < 0.1% |
| 5.013578 | 3 | < 0.1% |
| 6.631992 | 3 | < 0.1% |
| 6.065001 | 3 | < 0.1% |
| 3.238915 | 3 | < 0.1% |
| 3.484128 | 3 | < 0.1% |
| 4.678753 | 3 | < 0.1% |
| 5.688532 | 3 | < 0.1% |
| Other values (241358) | 245828 | |
| (Missing) | 4213 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 4243 | |
| 0.122645 | 1 | < 0.1% |
| 0.143324 | 1 | < 0.1% |
| 0.208879 | 1 | < 0.1% |
| 0.246496 | 1 | < 0.1% |
| 0.330284 | 1 | < 0.1% |
| 0.357559 | 1 | < 0.1% |
| 0.363016 | 1 | < 0.1% |
| 0.415321 | 1 | < 0.1% |
| 0.41898 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 66.66148 | 1 | |
| 66.61517 | 1 | |
| 65.48769 | 1 | |
| 65.31937 | 1 | |
| 64.44538 | 1 | |
| 64.30639 | 1 | |
| 64.23135 | 1 | |
| 64.13335 | 1 | |
| 64.05045 | 1 | |
| 64.03623 | 1 |
MP1 PDEPTH_1 (mm)
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWED| Distinct | 9727 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 4213 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.65428626 |
| Minimum | 0 |
|---|---|
| Maximum | 2604.37 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 40.37 |
| Q1 | 52.19 |
| median | 59.47 |
| Q3 | 66.6 |
| 95-th percentile | 80.68 |
| Maximum | 2604.37 |
| Range | 2604.37 |
| Interquartile range (IQR) | 14.41 |
Descriptive statistics
| Standard deviation | 46.62398603 |
|---|---|
| Coefficient of variation (CV) | 0.7686841096 |
| Kurtosis | 1719.003472 |
| Mean | 60.65428626 |
| Median Absolute Deviation (MAD) | 7.2 |
| Skewness | 38.566953 |
| Sum | 15169576.34 |
| Variance | 2173.796073 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.73 | 137 | 0.1% |
| 58.74 | 128 | 0.1% |
| 61.26 | 127 | < 0.1% |
| 58.56 | 126 | < 0.1% |
| 58.97 | 122 | < 0.1% |
| 58.36 | 122 | < 0.1% |
| 57.94 | 122 | < 0.1% |
| 57.83 | 121 | < 0.1% |
| 60.8 | 121 | < 0.1% |
| 59.84 | 120 | < 0.1% |
| Other values (9717) | 248853 | |
| (Missing) | 4213 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 5.71 | 1 | |
| 5.89 | 1 | |
| 5.92 | 1 | |
| 6.15 | 1 | |
| 6.45 | 1 | |
| 6.46 | 1 | |
| 6.53 | 2 | |
| 6.57 | 1 | |
| 6.74 | 2 |
| Value | Count | Frequency (%) |
| 2604.37 | 1 | |
| 2597.59 | 1 | |
| 2584.69 | 1 | |
| 2570.91 | 1 | |
| 2568.81 | 1 | |
| 2552.14 | 1 | |
| 2551.7 | 1 | |
| 2535.91 | 1 | |
| 2500.16 | 1 | |
| 2481.31 | 1 |
MP1 UNIDEPTH (mm)
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGSKEWED| Distinct | 8083 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 4213 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.01146074 |
| Minimum | -253.75 |
|---|---|
| Maximum | 2604.37 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | -253.75 |
|---|---|
| 5-th percentile | 40.44 |
| Q1 | 52.06 |
| median | 60.29 |
| Q3 | 66.83 |
| 95-th percentile | 79.66 |
| Maximum | 2604.37 |
| Range | 2858.12 |
| Interquartile range (IQR) | 14.77 |
Descriptive statistics
| Standard deviation | 46.43689921 |
|---|---|
| Coefficient of variation (CV) | 0.7611176432 |
| Kurtosis | 1745.716519 |
| Mean | 61.01146074 |
| Median Absolute Deviation (MAD) | 7.32 |
| Skewness | 39.01797907 |
| Sum | 15258905.32 |
| Variance | 2156.385608 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.36 | 126 | < 0.1% |
| 62.35 | 126 | < 0.1% |
| 62.24 | 125 | < 0.1% |
| 61.74 | 125 | < 0.1% |
| 61.96 | 124 | < 0.1% |
| 61.8 | 124 | < 0.1% |
| 61.98 | 124 | < 0.1% |
| 63.75 | 124 | < 0.1% |
| 64.02 | 124 | < 0.1% |
| 62.27 | 124 | < 0.1% |
| Other values (8073) | 248853 | |
| (Missing) | 4213 | 1.7% |
| Value | Count | Frequency (%) |
| -253.75 | 1 | |
| 12.16 | 1 | |
| 12.45 | 1 | |
| 12.68 | 1 | |
| 12.86 | 1 | |
| 12.91 | 1 | |
| 12.95 | 1 | |
| 13.02 | 1 | |
| 13.11 | 1 | |
| 13.27 | 1 |
| Value | Count | Frequency (%) |
| 2604.37 | 1 | |
| 2597.59 | 1 | |
| 2584.69 | 1 | |
| 2570.91 | 1 | |
| 2568.81 | 1 | |
| 2552.14 | 1 | |
| 2551.7 | 1 | |
| 2535.91 | 1 | |
| 2500.16 | 1 | |
| 2481.31 | 1 |
MP1 UpDEPTH_1 (mm)
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSING| Distinct | 8004 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 4213 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.15066026 |
| Minimum | -253.75 |
|---|---|
| Maximum | 435.06 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | -253.75 |
|---|---|
| 5-th percentile | 40.45 |
| Q1 | 52.06 |
| median | 60.29 |
| Q3 | 66.83 |
| 95-th percentile | 79.66 |
| Maximum | 435.06 |
| Range | 688.81 |
| Interquartile range (IQR) | 14.77 |
Descriptive statistics
| Standard deviation | 15.97931283 |
|---|---|
| Coefficient of variation (CV) | 0.2656548201 |
| Kurtosis | 228.5955856 |
| Mean | 60.15066026 |
| Median Absolute Deviation (MAD) | 7.32 |
| Skewness | 9.985162944 |
| Sum | 15043619.98 |
| Variance | 255.3384385 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.36 | 126 | < 0.1% |
| 62.35 | 126 | < 0.1% |
| 61.74 | 125 | < 0.1% |
| 62.24 | 125 | < 0.1% |
| 61.96 | 124 | < 0.1% |
| 61.8 | 124 | < 0.1% |
| 62.27 | 124 | < 0.1% |
| 64.02 | 124 | < 0.1% |
| 63.75 | 124 | < 0.1% |
| 61.98 | 124 | < 0.1% |
| Other values (7994) | 248853 | |
| (Missing) | 4213 | 1.7% |
| Value | Count | Frequency (%) |
| -253.75 | 1 | |
| 25.81 | 1 | |
| 25.88 | 1 | |
| 25.94 | 1 | |
| 26 | 1 | |
| 26.06 | 1 | |
| 26.09 | 1 | |
| 26.16 | 1 | |
| 26.64 | 1 | |
| 26.74 | 1 |
| Value | Count | Frequency (%) |
| 435.06 | 1 | |
| 434.95 | 1 | |
| 434.77 | 1 | |
| 434.37 | 1 | |
| 434.27 | 1 | |
| 434.2 | 1 | |
| 434.19 | 1 | |
| 434.14 | 2 | |
| 434.13 | 1 | |
| 434.11 | 2 |
| Distinct | 142 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 4213 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.29478966 |
| Minimum | -17.8 |
|---|---|
| Maximum | 23.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | -17.8 |
|---|---|
| 5-th percentile | 12.1 |
| Q1 | 14.1 |
| median | 15.9 |
| Q3 | 18.7 |
| 95-th percentile | 20.9 |
| Maximum | 23.3 |
| Range | 41.1 |
| Interquartile range (IQR) | 4.6 |
Descriptive statistics
| Standard deviation | 2.762145857 |
|---|---|
| Coefficient of variation (CV) | 0.1695109857 |
| Kurtosis | -0.9221257188 |
| Mean | 16.29478966 |
| Median Absolute Deviation (MAD) | 2.2 |
| Skewness | 0.1881975 |
| Sum | 4075310.6 |
| Variance | 7.629449737 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14.8 | 4655 | 1.8% |
| 14.3 | 4581 | 1.8% |
| 14.6 | 4553 | 1.8% |
| 15.3 | 4370 | 1.7% |
| 15.1 | 4194 | 1.6% |
| 13.8 | 4183 | 1.6% |
| 14.1 | 4157 | 1.6% |
| 14.5 | 3850 | 1.5% |
| 15 | 3797 | 1.5% |
| 15.6 | 3650 | 1.4% |
| Other values (132) | 208109 | |
| (Missing) | 4213 | 1.7% |
| Value | Count | Frequency (%) |
| -17.8 | 1 | < 0.1% |
| 8.9 | 3 | < 0.1% |
| 9 | 1 | < 0.1% |
| 9.1 | 3 | < 0.1% |
| 9.5 | 6 | < 0.1% |
| 9.6 | 4 | < 0.1% |
| 9.7 | 3 | < 0.1% |
| 9.8 | 4 | < 0.1% |
| 10 | 8 | |
| 10.1 | 15 |
| Value | Count | Frequency (%) |
| 23.3 | 3 | < 0.1% |
| 23.2 | 3 | < 0.1% |
| 23.1 | 8 | < 0.1% |
| 23 | 8 | < 0.1% |
| 22.9 | 24 | < 0.1% |
| 22.8 | 20 | < 0.1% |
| 22.7 | 39 | |
| 22.6 | 37 | |
| 22.5 | 46 | |
| 22.4 | 69 |
Raw Average Velocity (m/s)
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONMISSINGZEROS| Distinct | 895 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 4213 |
| Missing (%) | 1.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3843306742 |
| Minimum | 0 |
|---|---|
| Maximum | 0.9531 |
| Zeros | 4243 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.189 |
| Q1 | 0.3249 |
| median | 0.4041 |
| Q3 | 0.4563 |
| 95-th percentile | 0.522 |
| Maximum | 0.9531 |
| Range | 0.9531 |
| Interquartile range (IQR) | 0.1314 |
Descriptive statistics
| Standard deviation | 0.1091561765 |
|---|---|
| Coefficient of variation (CV) | 0.284016301 |
| Kurtosis | 1.736174111 |
| Mean | 0.3843306742 |
| Median Absolute Deviation (MAD) | 0.063 |
| Skewness | -0.8131069782 |
| Sum | 96120.7173 |
| Variance | 0.01191507086 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4243 | 1.7% |
| 0.4383 | 1261 | 0.5% |
| 0.432 | 1246 | 0.5% |
| 0.4374 | 1228 | 0.5% |
| 0.4392 | 1213 | 0.5% |
| 0.4365 | 1206 | 0.5% |
| 0.4347 | 1195 | 0.5% |
| 0.4356 | 1194 | 0.5% |
| 0.4302 | 1185 | 0.5% |
| 0.4338 | 1184 | 0.5% |
| Other values (885) | 234944 | |
| (Missing) | 4213 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 4243 | |
| 0.0144 | 1 | < 0.1% |
| 0.018 | 1 | < 0.1% |
| 0.0261 | 1 | < 0.1% |
| 0.027 | 1 | < 0.1% |
| 0.0288 | 1 | < 0.1% |
| 0.0306 | 2 | < 0.1% |
| 0.0342 | 1 | < 0.1% |
| 0.0432 | 1 | < 0.1% |
| 0.0441 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.9531 | 1 | |
| 0.8946 | 1 | |
| 0.8901 | 1 | |
| 0.8829 | 1 | |
| 0.882 | 1 | |
| 0.8775 | 1 | |
| 0.8757 | 1 | |
| 0.8748 | 1 | |
| 0.8739 | 1 | |
| 0.8712 | 2 |
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.49995281 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 10597 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 11 |
| Q3 | 17.25 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 12.25 |
Descriptive statistics
| Standard deviation | 6.922248068 |
|---|---|
| Coefficient of variation (CV) | 0.6019370844 |
| Kurtosis | -1.204177677 |
| Mean | 11.49995281 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.599801282 × 10-5 |
| Sum | 2924576 |
| Variance | 47.91751831 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 23 | 10598 | 4.2% |
| 4 | 10598 | 4.2% |
| 8 | 10597 | 4.2% |
| 6 | 10597 | 4.2% |
| 0 | 10597 | 4.2% |
| 12 | 10597 | 4.2% |
| 15 | 10596 | 4.2% |
| 22 | 10596 | 4.2% |
| 21 | 10596 | 4.2% |
| 20 | 10596 | 4.2% |
| Other values (14) | 148344 |
| Value | Count | Frequency (%) |
| 0 | 10597 | |
| 1 | 10596 | |
| 2 | 10596 | |
| 3 | 10596 | |
| 4 | 10598 | |
| 5 | 10596 | |
| 6 | 10597 | |
| 7 | 10596 | |
| 8 | 10597 | |
| 9 | 10596 |
| Value | Count | Frequency (%) |
| 23 | 10598 | |
| 22 | 10596 | |
| 21 | 10596 | |
| 20 | 10596 | |
| 19 | 10596 | |
| 18 | 10596 | |
| 17 | 10596 | |
| 16 | 10596 | |
| 15 | 10596 | |
| 14 | 10596 |
day
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.73617446 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.805063711 |
|---|---|
| Coefficient of variation (CV) | 0.5595428375 |
| Kurtosis | -1.193283463 |
| Mean | 15.73617446 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.007382156183 |
| Sum | 4001898 |
| Variance | 77.52914695 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 19 | 8354 | 3.3% |
| 14 | 8353 | 3.3% |
| 5 | 8353 | 3.3% |
| 22 | 8353 | 3.3% |
| 1 | 8353 | 3.3% |
| 28 | 8353 | 3.3% |
| 6 | 8352 | 3.3% |
| 18 | 8352 | 3.3% |
| 27 | 8352 | 3.3% |
| 26 | 8352 | 3.3% |
| Other values (21) | 170785 |
| Value | Count | Frequency (%) |
| 1 | 8353 | |
| 2 | 8352 | |
| 3 | 8352 | |
| 4 | 8352 | |
| 5 | 8353 | |
| 6 | 8352 | |
| 7 | 8352 | |
| 8 | 8352 | |
| 9 | 8352 | |
| 10 | 8352 |
| Value | Count | Frequency (%) |
| 31 | 5184 | |
| 30 | 7489 | |
| 29 | 7776 | |
| 28 | 8353 | |
| 27 | 8352 | |
| 26 | 8352 | |
| 25 | 8352 | |
| 24 | 8352 | |
| 23 | 8352 | |
| 22 | 8353 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.926397496 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.461526366 |
|---|---|
| Coefficient of variation (CV) | 0.5840860942 |
| Kurtosis | -1.167999473 |
| Mean | 5.926397496 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.2512528015 |
| Sum | 1507154 |
| Variance | 11.98216478 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 26785 | |
| 1 | 26784 | |
| 3 | 26784 | |
| 4 | 25921 | |
| 2 | 24482 | |
| 12 | 18144 | |
| 10 | 17858 | |
| 7 | 17856 | |
| 8 | 17856 | |
| 6 | 17281 | |
| Other values (2) | 34561 |
| Value | Count | Frequency (%) |
| 1 | 26784 | |
| 2 | 24482 | |
| 3 | 26784 | |
| 4 | 25921 | |
| 5 | 26785 | |
| 6 | 17281 | |
| 7 | 17856 | |
| 8 | 17856 | |
| 9 | 17280 | |
| 10 | 17858 |
| Value | Count | Frequency (%) |
| 12 | 18144 | |
| 11 | 17281 | |
| 10 | 17858 | |
| 9 | 17280 | |
| 8 | 17856 | |
| 7 | 17856 | |
| 6 | 17281 | |
| 5 | 26785 | |
| 4 | 25921 | |
| 3 | 26784 |
| Distinct | 254312 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Minimum | 2018-12-31 00:00:00 |
|---|---|
| Maximum | 2021-06-01 00:00:00 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.0 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 230080 | |
| 1 | 24232 | 9.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 230080 | |
| 1 | 24232 | 9.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Daily Cumulative Rainfall (mm) | Final Rainfall (mm) | MP1 FLOW1 (l/s) | MP1 PDEPTH_1 (mm) | MP1 UNIDEPTH (mm) | MP1 UpDEPTH_1 (mm) | MP1 WATERTEMP_1 (°C) | Raw Average Velocity (m/s) | hour | day | month | date | targets | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0.0 | 0.0 | 2.744015 | 50.96 | 64.10 | 64.10 | 15.2 | 0.1962 | 0 | 31 | 12 | 2018-12-31 00:00:00 | 0 |
| 1 | 0.0 | 0.0 | 2.709665 | 63.41 | 64.85 | 64.85 | 15.1 | 0.1908 | 0 | 31 | 12 | 2018-12-31 00:05:00 | 0 |
| 2 | 0.0 | 0.0 | 2.720578 | 64.29 | 63.58 | 63.58 | 15.1 | 0.1971 | 0 | 31 | 12 | 2018-12-31 00:10:00 | 0 |
| 3 | 0.0 | 0.0 | 2.394623 | 64.10 | 58.52 | 58.52 | 15.1 | 0.1962 | 0 | 31 | 12 | 2018-12-31 00:15:00 | 0 |
| 4 | 0.0 | 0.0 | 2.316329 | 63.89 | 57.02 | 57.02 | 15.0 | 0.1971 | 0 | 31 | 12 | 2018-12-31 00:20:00 | 0 |
| 5 | 0.0 | 0.0 | 1.701397 | 63.73 | 45.51 | 45.51 | 14.9 | 0.1998 | 0 | 31 | 12 | 2018-12-31 00:25:00 | 0 |
| 6 | 0.0 | 0.0 | 2.268245 | 63.68 | 56.34 | 56.34 | 15.0 | 0.1962 | 0 | 31 | 12 | 2018-12-31 00:30:00 | 0 |
| 7 | 0.0 | 0.0 | 2.572402 | 63.84 | 59.65 | 59.65 | 15.0 | 0.2043 | 0 | 31 | 12 | 2018-12-31 00:35:00 | 0 |
| 8 | 0.0 | 0.0 | 2.528456 | 63.72 | 58.98 | 58.98 | 14.8 | 0.2043 | 0 | 31 | 12 | 2018-12-31 00:40:00 | 0 |
| 9 | 0.0 | 0.0 | 2.210480 | 62.90 | 57.50 | 57.50 | 14.8 | 0.1854 | 0 | 31 | 12 | 2018-12-31 00:45:00 | 0 |
Last rows
| Daily Cumulative Rainfall (mm) | Final Rainfall (mm) | MP1 FLOW1 (l/s) | MP1 PDEPTH_1 (mm) | MP1 UNIDEPTH (mm) | MP1 UpDEPTH_1 (mm) | MP1 WATERTEMP_1 (°C) | Raw Average Velocity (m/s) | hour | day | month | date | targets | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 254302 | 0.0 | 0.0 | 0.00000 | 83.83 | 79.50 | 79.50 | 15.4 | 0.0000 | 23 | 31 | 5 | 2021-05-31 23:15:00 | 1 |
| 254303 | 0.0 | 0.0 | 4.31069 | 85.13 | 79.43 | 79.43 | 15.3 | 0.2430 | 23 | 31 | 5 | 2021-05-31 23:20:00 | 1 |
| 254304 | 0.0 | 0.0 | 0.00000 | 85.36 | 79.35 | 79.35 | 15.4 | 0.0000 | 23 | 31 | 5 | 2021-05-31 23:25:00 | 1 |
| 254305 | 0.0 | 0.0 | 0.00000 | 84.30 | 79.19 | 79.19 | 15.4 | 0.0000 | 23 | 31 | 5 | 2021-05-31 23:30:00 | 1 |
| 254306 | 0.0 | 0.0 | 0.00000 | 83.82 | 79.07 | 79.07 | 15.3 | 0.0000 | 23 | 31 | 5 | 2021-05-31 23:35:00 | 1 |
| 254307 | 0.0 | 0.0 | 0.00000 | 83.92 | 78.88 | 78.88 | 15.3 | 0.0000 | 23 | 31 | 5 | 2021-05-31 23:40:00 | 1 |
| 254308 | 0.0 | 0.0 | 0.00000 | 83.66 | 78.70 | 78.70 | 15.3 | 0.0000 | 23 | 31 | 5 | 2021-05-31 23:45:00 | 1 |
| 254309 | 0.0 | 0.0 | 3.96669 | 83.75 | 78.65 | 78.65 | 15.3 | 0.2268 | 23 | 31 | 5 | 2021-05-31 23:50:00 | 1 |
| 254310 | 0.0 | 0.0 | 0.00000 | 83.90 | 78.54 | 78.54 | 15.3 | 0.0000 | 23 | 31 | 5 | 2021-05-31 23:55:00 | 1 |
| 254311 | 0.0 | 0.0 | 0.00000 | 82.96 | 78.44 | 78.44 | 15.2 | 0.0000 | 0 | 1 | 6 | 2021-06-01 00:00:00 | 1 |